MikMak logisch model
Home

MikMak logisch model

MikMak logisch model

Het logische datamodel beschrijft de structuur van en de referenties tussen de logische gegevensobjecten, die meer gelijken op tabellen dan op entiteiten.

Data Structure Diagram

Alle uitleg over de DSD van An Orm Apart vind je op Data Structure Diagram voor An Orm Apart.

Country

Land

Name
Column Name Display Text Searchable Default Value Unique Type Length Variable International Required Reference Table Reference Column Display Column List HTML element HTML type attribute HTML name attribute HTML pattern attribute HTML title attribute HTML placeholder attribute
Code Code SELECTBY NO YES CHAR 2 YES YES YES NA NA NA YES INPUT TEXT code NA NA NA
Latitude Breedtegraad NO NO NO FLOAT NA NO NA NO NA NA NA NO INPUT TEXT latidtude NA NA NA
Longitude Lengtegraad NO NO NO FLOAT NA NO NA NO NA NA NA NO INPUT TEXT longitude NA NA NA
Name Naam SELECTBY NO YES CHAR 255 YES YES YES NA NA NA YES INPUT TEXT name NA NA NA
ShippingCostMultiplier Verzendkosten NO NO NO FLOAT NA NA NA NO NA NA NA YES INPUT TEXT shippingcostmultiplier NA NA NA
Id NA NA PK YES Integer NA NA NA Yes NA NA NA YES INPUT HIDDEN id NA NA NA

OrderStatus

Status bestelling

Name
Column Name Display Text Searchable Default Value Unique Type Length Variable International Required Reference Table Reference Column Display Column List HTML element HTML type attribute HTML name attribute HTML pattern attribute HTML title attribute HTML placeholder attribute
Name Naam SELECTBY NO YES CHAR 255 YES YES YES NA NA NA YES INPUT TEXT name NA NA NA
Description Beschrijving NO NO NO CHAR 1024 YES YES NO NA NA NA NO TEXTEAREA NA description NA NA NA
Id NA NA PK YES Integer NA NA NA Yes NA NA NA YES INPUT HIDDEN id NA NA NA

Category

Categorie

Name
Column Name Display Text Searchable Default Value Unique Type Length Variable International Required Reference Table Reference Column Display Column List HTML element HTML type attribute HTML name attribute HTML pattern attribute HTML title attribute HTML placeholder attribute
Name Naam SELECTBY NO YES CHAR 255 YES YES YES NA NA NA YES INPUT TEXT name NA NA NA
Description Beschrijving NO NO NO CHAR 1024 YES YES NO NA NA NA NO TEXTEAREA NA description NA NA NA
Id NA NA PK YES Integer NA NA NA Yes NA NA NA YES INPUT HIDDEN id NA NA NA

UnitBase

Basiseenheid

Name
Column Name Display Text Searchable Default Value Unique Type Length Variable International Required Reference Table Reference Column Display Column List HTML element HTML type attribute HTML name attribute HTML pattern attribute HTML title attribute HTML placeholder attribute
Name Naam SELECTBY NO YES CHAR 255 YES YES YES NA NA NA YES INPUT TEXT name NA NA NA
Description Beschrijving NO NO NO CHAR 1024 YES YES NO NA NA NA NO TEXTEAREA NA description NA NA NA
ShippingCostMultiplier Verzendkostenfactor NO NO NO FLOAT NA NA NA NO NA NA NA YES INPUT TEXT shippingcostmultiplier NA NA NA
Code Code SELECTBY NO YES CHAR 2 YES YES YES NA NA NA YES INPUT TEXT code NA NA NA
Id NA NA PK YES Integer NA NA NA Yes NA NA NA YES INPUT HIDDEN id NA NA NA

ShippingMethod

Verzendingswijze

Name
Column Name Display Text Searchable Default Value Unique Type Length Variable International Required Reference Table Reference Column Display Column List HTML element HTML type attribute HTML name attribute HTML pattern attribute HTML title attribute HTML placeholder attribute
Name Naam SELECTBY NO YES CHAR 255 YES YES YES NA NA NA YES INPUT TEXT name NA NA NA
Description Beschrijving NO NO NO CHAR 1024 YES YES NO NA NA NA NO TEXTEAREA NA description NA NA NA
Price Kostprijs NO NO NO DECIMAL 6,2 NA NA YES NA NA NA YES INPUT TEXT price NA NA NA
Id NA NA PK YES Integer NA NA NA Yes NA NA NA YES INPUT HIDDEN id NA NA NA

Supplier

Leverancier

Name
Column Name Display Text Searchable Default Value Unique Type Length Variable International Required Reference Table Reference Column Display Column List HTML element HTML type attribute HTML name attribute HTML pattern attribute HTML title attribute HTML placeholder attribute
Code Code SELECTBY NO YES CHAR 10 YES YES YES NA NA NA YES INPUT TEXT code NA NA NA
Name Naam SELECTBY NO YES CHAR 255 YES YES YES NA NA NA YES INPUT TEXT name NA NA NA
Contact Contact SELECTBY NO NO CHAR 255 YES YES NO NA NA NA NO INPUT TEXT contact NA NA NA
Address Adres NO NO NO CHAR 255 YES YES NO NA NA NA NO INPUT TEXT address NA NA NA
City Stad NO NO NO CHAR 255 YES YES NO NA NA NA NO INPUT TEXT city NA NA NA
Region Regio NO NO NO CHAR 80 YES YES NO NA NA NA NO INPUT TEXT region NA NA NA
PostalCode Postcode NO NO NO CHAR 20 YES NO NO NA NA NA NO INPUT TEXT postalcode NA NA NA
IdCountry Land NO NO NO Integer MANY NA NA YES Country Id Name YES INPUT TEXT idcountry NA NA NA
Phone Telefoon NO NO NO CHAR 40 YES NO NO NA NA NA NO INPUT TEXT phone NA NA NA
Mobile Mobiel NO NO NO CHAR 40 YES NO NO NA NA NA NO INPUT TEXT mobile NA NA NA
Id NA NA PK YES Integer NA NA NA Yes NA NA NA YES INPUT HIDDEN id NA NA NA

Customer

Klant

LastName, FirstName
Column Name Display Text Searchable Default Value Unique Type Length Variable International Required Reference Table Reference Column Display Column List HTML element HTML type attribute HTML name attribute HTML pattern attribute HTML title attribute HTML placeholder attribute
NickName Roepnaam SELECTBY NO NO CHAR 10 YES YES YES NA NA NA YES INPUT TEXT code NA NA NA
FirstName Voornaam NO NO NO CHAR 255 YES YES YES NA NA NA YES INPUT TEXT name NA NA NA
LastName Familienaam SELECTBY NO NO CHAR 255 YES YES YES NA NA NA YES INPUT TEXT contact NA NA NA
Address1 Adres 1 NO NO NO CHAR 255 YES YES YES NA NA NA NO INPUT TEXT address1 NA NA NA
Address2 Adres 2 NO NO CHAR 255 YES YES NO NA NA NA NO INPUT TEXT address2 NA NA NA
City Stad NO NO NO CHAR 255 YES YES YES NA NA NA YES INPUT TEXT city NA NA NA
Region Regio NO NO NO CHAR 80 YES YES NO NA NA NA NO INPUT TEXT region NA NA NA
PostalCode Postcode SELECTBY NO NO CHAR 20 YES NO YES NA NA NA NO INPUT TEXT postalcode NA NA NA
IdCountry Land SELECTBY NO NO Integer MANY NA NA YES Country Id Name YES INPUT TEXT idcountry NA NA NA
Phone Telefoon NO NO NO CHAR 40 YES NO NO NA NA NA NO INPUT TEXT phone NA NA NA
Mobile Mobieltje NO NO NO CHAR 40 YES NO NO NA NA NA NO INPUT TEXT mobile NA NA NA
Id NA NA PK YES Integer NA NA NA Yes NA NA NA YES INPUT HIDDEN id NA NA NA

Product

Product

Name
Column Name Display Text Searchable Default Value Unique Type Length Variable International Required Reference Table Reference Column Display Column List HTML element HTML type attribute HTML name attribute HTML pattern attribute HTML title attribute HTML placeholder attribute
Description Beschrijving NO NO NO CHAR 1024 YES YES NO NA NA NA NO TEXTEAREA NA description NA NA NA
Name Naam SELECTX NO YES CHAR 255 YES YES YES NA NA NA YES INPUT TEXT name NA NA NA
Price Prijs NO NO NO FLOAT NA NA NA NO NA NA NA YES INPUT TEXT price NA NA NA
ShippingCost Verzendkosten NO NO NO FLOAT NA NA NA NO NA NA NA YES INPUT TEXT shippingcost NA NA NA
TotalRating Totaal rating NO NO NO Integer NA NA NA NO NA NA NA YES INPUT TEXT totalrating NA NA NA
Thumbnail Miniatuur NO NO NO CHAR 255 YES NO NO NA NA NA NO INPUT TEXT thumbnail NA NA NA
Image Afbeelding NO NO NO CHAR 255 YES NO NO NA NA NA NO INPUT TEXT image NA NA NA
DiscountPercentage Aanbiedingspercent NO NO NO FLOAT NA NA NA NO NA NA NA YES INPUT TEXT DiscountPercentage NA NA NA
Votes Stemmen NO NO NO Integer NA NA NA NO NA NA NA YES INPUT TEXT votes NA NA NA
Id NA NA PK YES Integer NA NA NA Yes NA NA NA YES INPUT HIDDEN id NA NA NA
IdSupplier Leverancier YES NO NO Integer NA NA NA YES Supplier Id Name YES INPUT HIDDEN idarticle NA NA NA
IdCategory Categorie YES NO NO Integer NA NA NA YES Category Id Name YES INPUT HIDDEN idcategory NA NA NA

Order

Bestelling

OrderDate
Column Name Display Text Searchable Default Value Unique Type Length Variable International Required Reference Table Reference Column Display Column List HTML element HTML type attribute HTML name attribute HTML pattern attribute HTML title attribute HTML placeholder attribute
OrderDate Besteldatum SELECTBY NO NO DATETIME NA NA NA YES NA NA NA YES INPUT TEXT orderdate NA NA NA
ShippingDate Verzenddatum SELECTBY NO NO DATETIME NA NA NA YES NA NA NA YES INPUT TEXT shippingdate NA NA NA
Comment Opmerking NO NO NO CHAR 512 YES YES NO NA NA NA NO TEXTEREA comment NA NA NA
Id NA NA PK YES Integer NA NA NA Yes NA NA NA YES INPUT HIDDEN id NA NA NA
IdCustomer Klant YES NO NO Integer NA NA NA YES Customer Id LastName YES INPUT HIDDEN idarticle NA NA NA
IdShippingMethod Verzendigsmethode NO NO NO Integer NA NA NA YES ShippingMethod Id Name YES INPUT HIDDEN idarticle NA NA NA
IdStatus Status NO NO NO Integer NA NA NA YES OrderStatus Id Name YES INPUT HIDDEN idarticle NA NA NA

OrderItem

Details bestelling

Column Name Display Text Searchable Default Value Unique Type Length Variable International Required Reference Table Reference Column Display Column List HTML element HTML type attribute HTML name attribute HTML pattern attribute HTML title attribute HTML placeholder attribute
IdProduct Product NO NO NO Integer NA NA NA YES Product Id Name YES INPUT HIDDEN idproduct NA NA NA
IdOrder Bestelling NO NO NO Integer NA NA NA YES Order Id Id YES INPUT HIDDEN idorder NA NA NA
Id NA NO PK YES Integer NA NA NA Yes NA NA NA NA INPUT HIDDEN id NA NA NA
Quantity Hoeveelheid NO NA NO DECIMAL 4,2 NA NA NO NA NA NA YES INPUT TEXT quantity NA NA NA
JI
2017-01-18 16:42:12